package com.widetrust.carpro.dao.query;
/**
 * @author zwh
 * AGU 20, 2008 10:48:46 AM
 */
import java.sql.Types;
import java.util.List;

import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;

import com.widetrust.carpro.dao.basedata.IInsuranceProductDao;
import com.widetrust.carpro.domain.insuremanage.QueryBean;
import com.widetrust.carpro.domain.insuremanage.fee.InsuranceProductBean;
import com.widetrust.carpro.orm.RowMapperForSpringJDBC;
import com.widetrust.config.sqlbeans.Statements;
import com.widetrust.helper.ResourceUtils;

public class IQueryDao extends SimpleJdbcDaoSupport implements QueryInterfaceDao {
	
	public List<QueryBean> getQueryquashList(String insuranceOrderId ){
		
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getQueryquashList");
		String[] para = new String[]{ insuranceOrderId };
		
		List<QueryBean> queryquashList = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		
		return queryquashList;
	}
	
	public List<QueryBean> getQueryquashList_postil( String insuranceOrderId ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getQueryquashList_postil");
		String[] para = new String[]{ insuranceOrderId };
		
		List<QueryBean> queryquashList_postil = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		
		return queryquashList_postil;
	}
	
	public List<QueryBean> getQueryCancleList( String insuranceOrderId ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getQueryCancleList");
		String[] para = new String[]{ insuranceOrderId };
		
		List<QueryBean> querycancleList = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return querycancleList;
	}
	public List<QueryBean> getDayQueryList( String insuranceOrderId ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getDayQueryList");
		String[] para = new String[]{insuranceOrderId };
		
		List<QueryBean> dayqueryleList = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return dayqueryleList;
	}
	public List<QueryBean> getDayQueryList2( String insuranceOrderId2 ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getDayQueryList2");
		String[] para = new String[]{insuranceOrderId2};
		
		List<QueryBean> dayqueryleList2 = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return dayqueryleList2;
	}
	public List<QueryBean> getInsurQueryList( String insuranceOrderId ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getInsurQueryList");
		String[] para = new String[]{ insuranceOrderId };
		
		List<QueryBean> insurqueryList = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return insurqueryList;
	}
	public List<QueryBean> getInsurQueryList2( String insuranceOrderId2 ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getInsurQueryList2");
		String[] para = new String[]{ insuranceOrderId2 };
		
		List<QueryBean> insurqueryList2 = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return insurqueryList2;
	}
	public List<QueryBean> getpremiumQueryList( String insuranceOrderId ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getpremiumQueryList");
		String[] para = new String[]{ insuranceOrderId };
		
		List<QueryBean> premiumqueryList = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return premiumqueryList;
	}
	public List<QueryBean> getpremiumQueryList2( String insuranceOrderId2 ){
		Statements statements=ResourceUtils.getStatements();
		String sql = statements.getSQLStatement("getpremiumQueryList2");
		String[] para = new String[]{ insuranceOrderId2 };
		
		List<QueryBean> premiumqueryList2 = getJdbcTemplate().query( sql,para,
				new RowMapperForSpringJDBC( QueryBean.class));
		return premiumqueryList2;
	}
}